|
Internal Name: |
Postgres Server |
|
Description: |
PostgreSQL Server |
|
Singleton: |
no |
|
Plugin: |
Postgres |
|
Name |
Query |
|
unix |
process|basename|match=^(postgres|postmaster)$,process|basename|nomatch|parent=^(postgres|postmaster)$ |
|
windows |
process|basename|match=^(?i)(postgres|postmaster)\.exe$,process|basename|nomatch|parent=^(?i)(postgres|postmaster)\.exe$ |
|
Name |
Description |
Required |
Internal Name |
|
listen host |
the hostname or IP address that the database is listening on |
yes |
host |
|
listen port |
the TCP port that the database is listening on |
yes |
port |
|
database name |
the name of the database to connect to |
yes |
db |
|
JDBC driver class |
the fully-qualified classname of the JDBC driver class |
no |
driverClass |
|
role name |
the database role to connect as |
yes |
principal |
|
role password |
the password for the database role being used to connect |
yes |
credentials |
|
PGDATA directory |
the absolute path to the directory containing the cluster configuration files postgresql.conf, pg_hba.conf, and pg_ident.conf |
yes |
pgdataDir |
|
configuration file |
the absolute path to the main cluster configuration file; default value is '{pgDataDir}/postgresql.conf', where [pgDataDir] is the value of the pgDataDir connection property |
no |
configFile |
You must use the internal name to reference properties in Dynamic Group Definition expressions.
|
Name |
Type |
Description |
Internal Name |
|
User Time |
measurement |
The aggregate amount of CPU user time spent by all postgres processes |
Process.aggregateCpu.user |
|
User Time per Minute |
measurement |
The aggregate amount of CPU user time spent by all postgres processes |
Process.aggregateCpu.user |
|
Kernel Time |
measurement |
The aggregate amount of CPU kernel time spent by all postgres processes |
Process.aggregateCpu.sys |
|
Kernel Time per Minute |
measurement |
The aggregate amount of CPU kernel time spent by all postgres processes |
Process.aggregateCpu.sys |
|
CPU Percentage |
measurement |
The percentage of CPU currently being used by all postgres processes |
Process.aggregateCpu.percent |
|
Physical Memory |
measurement |
The aggregate amount of resident memory used by all postgres processes |
Process.aggregateMemory.resident |
|
Virtual Memory |
measurement |
The aggregate amount of virtual memory used by all postgres processes |
Process.aggregateMemory.size |
|
Open File Descriptors |
measurement |
The aggregate number of file descriptors open by all postgres processes |
Process.aggregateFileDescriptor.total |
|
Active Backends |
measurement |
Number of currently active backends (user connections) |
Database.backends |
|
Start time |
trait |
Start time of the PostgreSQL database server |
Database.startTime |
You must use the internal name to reference traits in Dynamic Group Definition expressions.
|
Name |
Description |
Required |
Internal Name |
|
Port |
Sets the TCP port the server listens on; default value is '5432'. |
no |
port |
|
Max_connections |
Sets the maximum number of concurrent connections; default value is '100'. |
no |
max_connections |
|
Shared_buffers |
Sets the number of the shared memory buffers used by the server; default value is typically '1000'. |
no |
shared_buffers |
|
Max_fsm_pages |
Maximum FSM Pages, must be a minimum of max_fsm_relations*16, 6 bytes each) |
no |
max_fsm_pages |
|
Log_destination |
Available options depend on operating system; default value is 'stderr' |
no |
log_destination |
|
Redirect_stderr |
Enable capturing of stderr into log files; enabled by default |
no |
redirect_stderr |
|
Stats_start_collector |
needed for block or row stats; enabled by default |
no |
stats_start_collector |
|
Stats_block_level |
Enables the collection of block-level statistics on database activity; if this option is enabled, the data that is produced can be accessed via the pg_stat and pg_statio family of system views; disabled by default |
no |
stats_block_level |
|
Stats_row_level |
Enables the collection of row-level statistics on database activity; if this option is enabled, the data that is produced can be accessed via the pg_stat and pg_statio family of system views; disabled by default |
no |
stats_row_level |
|
Autovacuum |
Enable autovacuum subprocess? (requires stats_start_collector and stats_row_level to also be on); enabled by default |
no |
autovacuum |
|
Runtime Settings |
properties available from show all |
no |
runtimeSettings |
You must use the internal name to reference properties in Dynamic Group Definition expressions.
|
Name |
Description |
|
List Process Statistics |
List statistics about the currently executing postgres backends |